##ENSURE SPREADSHEET IS FILTERED FIRST RUN_DATE (oldest to newest) then by DATETIME (oldest to newest)
# Points to background correct
good_id_mc3_bg<-c(68:75, 925:932, 236:238, 1093:1095, 265:267, 1122:1123, 1979, 1980, 1982, 280:283, 1137:1140, 1994:1997, 665:668, 1522:1527, 145:149, 1002:1006, 694, 695, 697, 795, 1551, 1552, 1554, 163, 164, 166, 167, 1020, 1021, 1022, 1877, 1878, 2408, 2409, 2411 )#350
# 85:91, 899:906, 235:237, 1049:1051, 265:268, 1079:1080, 1893, 1894, 1896, 280:283, 1908:1911, 667:670,672, 149:153, 963:967, 706:708, 1520:1522, 2334:2336, 167, 168, 170, 171, 981:984, 1795, 1796
good_id_mc3_fall<-c(291:293, 295, 297, 299, 302, 305, 307, 933:935, 1061:1063, 1065, 351, 352, 354, 356, 358, 360, 362, 429, 366, 368, 370, 1096:1107, 373, 375:379, 381, 382, 390, 391, 1126, 1128, 1129, 1983:1990, 392, 394, 395, 397, 399, 401:403, 1141, 1146, 1998:2003, 2058, 2060, 2061, 2063, 2064, 672, 674:681, 1641:1650, 627:635, 438, 424, 625, 626, 1007:1014, 1016:1019, 715, 718:724, 638:641, 663, 664, 810, 811, 812, 813, 814, 1028, 1047, 1048:1056, 1880:1881, 1885, 1904:1913, 1652:1665, 2509:2523, 2538) #350
# 301:309, 907:909, 1014:1016, 320, 351:360, 430, 1052:1063, 373, 375:379, 381:384, 1085:1086, 1898:1904, 385:387, 389:393, 1912:1917, 1950:1954, 674, 676:683, 627:632, 634:636, 972:975, 977:980, 716, 718, 719, 721, 723, 724, 638:643, 988:997, 1797, 1799:1811
## # A tibble: 1 x 1
## n
## <int>
## 1 11
## # A tibble: 16 x 5
## # Groups: date [8]
## date site Cl NO3 PO4
## <date> <chr> <dbl> <dbl> <dbl>
## 1 2018-06-26 350 0.0873 0.0697 NA
## 2 2018-06-26 450 0.112 0.213 NA
## 3 2018-06-28 350 0.100 0.211 NA
## 4 2018-06-28 450 0.0975 0.005 NA
## 5 2018-06-30 350 0.118 0.100 0.005
## 6 2018-06-30 450 0.0956 0.0334 0.005
## 7 2018-07-02 350 0.121 0.005 0.005
## 8 2018-07-02 450 0.168 0.0438 0.005
## 9 2018-07-17 350 0.165 0.00737 NA
## 10 2018-07-17 450 0.0830 0.0649 NA
## 11 2018-07-19 350 0.239 0.0551 NA
## 12 2018-07-19 450 0.211 0.0663 NA
## 13 2018-07-21 350 0.202 0.0634 0.005
## 14 2018-07-21 450 0.791 0.108 0.005
## 15 2018-07-23 350 0.320 0.0602 0.005
## 16 2018-07-23 450 0.190 0.214 0.320